if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GetDistinctProjectEndPeriods]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[GetDistinctProjectEndPeriods]

go
-- =======================================================================
-- Procedure Name: dbo.GetDistinctProjectEndPeriods
--
-- Author:      Arthur Bianchini
--
-- Create date: 5/13/2008
--
-- Description: Returns list of 3 Project End periods (30, 60, and 90 days from project period end date)
--
-- Parameters:  None
--
--------------------------------------------------------------------------
-- Date        Initials  Modification
--------------------------------------------------------------------------
-- 
-- =======================================================================
CREATE PROCEDURE [dbo].[GetDistinctProjectEndPeriods]
 
AS
BEGIN

SELECT
 30 as ProjectEndPeriodID,
'30 Days From Project End' as ProjectEndPeriodSelected,
'30 Days From Project End'  as Description
UNION
SELECT
 60 as ProjectEndPeriodID,
'60 Days From Project End' as ProjectEndPeriodSelected,
'60 Days From Project End'  as Description
UNION
SELECT
 90 as ProjectEndPeriodID,
'90 Days From Project End' as ProjectEndPeriodSelected,
'90 Days From Project End'  as Description
ORDER BY Description
     
END


